Previous Day Closing Stock = 
VAR CurrentCOODate =
    SELECTEDVALUE('DIM - Date Table'[Date])

VAR PreviousCOODate =
CALCULATE (
    MAX ( 'DIM - Date Table'[Date] ),
    ALL ( ),
    'DIM - Date Table'[Date] < CurrentCOODate,
    'DIM - Date Table'[IsWorkingDay] = 1
)

VAR DataversePrevDay = 
CALCULATE (
    MAX ( 'Dataverse'[COO Date] ),
    ALL (),
    'Dataverse'[COO Date] = PreviousCOODate
)

RETURN

 CALCULATE (
     [Total Closing Stock], 
     ALL ( ),
     'Dataverse'[COO Date] = DataversePrevDay
 )